select * from table_product_search_view where status = 1 and collection = 'Tunics ' order by tlid desc

Tunics